Use Case: Create Entity Business Rule to Identify Data Anomaly
Scenario
A preliminary review of your entity Customer Master shows that it has data inconsistency. You want to identify the data attributes with the inconsistency and review the types of data inconsistency (for example if data is inaccurate or missing etc) and note down the rows with the incorrect data.
Solution
Create one or more entity business rules to check for inconsistency in all rows/records across all attributes in the entity.
Step 1: Create entity business rule
Example: Rule to identify empty attributes
The postcode attribute cannot be empty, however, you noticed that there are multiple instances where the information is missing. To identify exactly which postcode rows are empty, you create this rule:
Step 2: Run entity business rules analysis
Example: Run analysis of Incorrect Postcode and Data Duplicates rules
Once you have created all necessary entity business rules, run business rules analysis.
Step 3: Analyze data inconsistency
Example: Analyze Empty Postcode rule
Analyze the passing rows to identify the number of empty postcode attribute.
| 1. | Right -click Customer Master Entity > Business Rules > Drill down to Entity Business Rules. A list of the two business rules you created in Step 1 are listed. Notice, that 9.669% of all records have empty postcode attribute. |
| 2. | Select and right-click Empty Postcode, select Drill down to Passing Rows. A list of all records with empty postcode attribute is listed (76 of them). |
